import sqlite3

conn = sqlite3.connect('test.db')
cursor = conn.cursor()
cursor.execute('create table[exam] ([question] varchar(80) null ,[Answer_A] varchar(1) null ,[Answer_B] varchar(1) '
               'null ,[Answer_C] varchar(1) null ,[Answer_D] varchar(1) null ,[right_Answer] varchar (1) null)')
cursor.execute("insert into exam (question, Answer_A, Answer_B, Answer_C, Answer_D, right_Answer) values ("
               "'哈雷彗星的平均周期','54年','56年','73年','83年','C')")
cursor.execute("insert into exam (question, Answer_A, Answer_B, Answer_C, Answer_D, right_Answer) values ("
               "'夜郎自大中“夜郎”指的是现在哪个地方？','贵州','云南','广西','福建','A')")
cursor.execute("insert into exam (question, Answer_A, Answer_B, Answer_C, Answer_D, right_Answer) values ("
               "'在中国的历史上谁发明了麻药？','孙思邈','张仲景','华佗','扁鹊','C')")
cursor.execute("insert into exam (question, Answer_A, Answer_B, Answer_C, Answer_D, right_Answer) values ('京剧中花旦指？',"
               "'年轻男子','年轻女子','年长男子','年长女子','B')")
cursor.execute("insert into exam (question, Answer_A, Answer_B, Answer_C, Answer_D, right_Answer) values ("
               "'篮球比赛每队几人？','4', "
               "'5','6','7','B')")
cursor.execute("insert into exam (question, Answer_A, Answer_B, Answer_C, Answer_D, right_Answer) values ("
               "'在天愿作比翼鸟，在地愿为连理枝。讲述的是谁的爱情故事？','焦仲卿和刘兰芝','梁山伯和祝英台','崔莺莺和张生','杨贵妃和唐明皇','D')")
print(cursor.rowcount)
cursor.close()
conn.commit()
conn.close()